LOAD DATA
TRUNCATE 
INTO TABLE gex_bdebdu_posd_tb
TRAILING NULLCOLS 
(line_no                	SEQUENCE(MAX)
,date_prod			POSITION(1:11)		"TO_DATE(:date_prod,'YYYY/MM/DD')"                      
,cd_portef			POSITION(12:27)		CHAR 
,cd_division			POSITION(28:39) 	CHAR
,cd_direction			POSITION(40:52) 	CHAR    
,cd_activite			POSITION(53:64)		CHAR
,cd_mode_gestion 		POSITION(65:80) 	CHAR
,cd_classe_actif		POSITION(81:96)		CHAR
,cd_type_gestion		POSITION(97:112)        CHAR
,cd_indice_comparaison		POSITION(113:134)	CHAR
,nom_portef			POSITION(135:150)   	CHAR
,provenance            		POSITION(151:161)	CHAR
,quantite         		POSITION(162:180)	"TO_NUMBER(:quantite,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_dev_local    	POSITION(181:202)	"TO_NUMBER(:valeur_cout_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_dev_cad      	POSITION(203:222)	"TO_NUMBER(:valeur_cout_dev_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_dev_usd      	POSITION(223:242)	"TO_NUMBER(:valeur_cout_dev_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_amort_dec_cad	POSITION(243:269)	"TO_NUMBER(:valeur_cout_amort_dec_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_unit_local  	POSITION(270:292)	"TO_NUMBER(:valeur_march_unit_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_unit_cad 		POSITION(293:314)	"TO_NUMBER(:valeur_march_unit_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_unit_usd 		POSITION(315:336)	"TO_NUMBER(:valeur_march_unit_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_dev_local		POSITION(337:359)	"TO_NUMBER(:valeur_march_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_dev_cad  		POSITION(360:380)	"TO_NUMBER(:valeur_march_dev_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_dev_usd  		POSITION(381:401)	"TO_NUMBER(:valeur_march_dev_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,ai_dev_local          		POSITION(402:420)	"DECODE(TRIM(:ai_dev_local),'NULL',null,TO_NUMBER(:ai_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. '''))" 
,ai_dev_cad            		POSITION(421:439)	"DECODE(TRIM(:ai_dev_cad),'NULL',null,TO_NUMBER(:ai_dev_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. '''))"
,vm_ai_dev_local       		POSITION(440:458)	"TO_NUMBER(:vm_ai_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,vm_ai_cad       		POSITION(459:477)	"TO_NUMBER(:vm_ai_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"	
,vm_ai_usd       		POSITION(478:496)	"TO_NUMBER(:vm_ai_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,numero_transaction    		POSITION(497:515)	"DECODE(TRIM(:numero_transaction),'NULL',null,TO_NUMBER(:numero_transaction))"
,id_gen  			POSITION(516:531)	"DECODE(TRIM(:id_gen),'NULL',null,:id_gen)"
,repo_rate                     	POSITION(532:552)	"DECODE(TRIM(:repo_rate),'NULL',null,ROUND(TO_NUMBER(:repo_rate,'9D99999999999999999','NLS_NUMERIC_CHARACTERS=''. '''),6))"
,cusip     			POSITION(553:565)	CHAR
,id_titre			POSITION(566:577)	"TRIM(:id_titre)"
,type_identifiant  		POSITION(578:617)	CHAR
,date_emission                 	POSITION(618:631)	"TO_DATE(:date_emission,'YYYY/MM/DD')"
,taux_int_nominal              	POSITION(632:652)	"ROUND(TO_NUMBER(:taux_int_nominal,'999D99999999999999999','NLS_NUMERIC_CHARACTERS=''. '''),6)"
,mature_date                   	POSITION(653:664)	"TO_DATE(:mature_date,'YYYY/MM/DD')"      
,titre     			POSITION(665:680)	CHAR
,cd_titre			POSITION(681:696)	CHAR
,cd_devise			POSITION(697:706)	CHAR
,article_loi     		POSITION(707:722)	CHAR
,indicat_vote  			POSITION(723:738)	CHAR
,nb_droit_vote     		POSITION(739:759)	"ROUND(TO_NUMBER(:nb_droit_vote,'999999D9999999999999999999','NLS_NUMERIC_CHARACTERS=''. '''),1)"
,cd_indice_primaire   		POSITION(760:778)	CHAR
,cd_autre_indice       		POSITION(779:794)	CHAR
,cd_autre_sect         		POSITION(795:808)	CHAR
,cd_autre_sous_sect    		POSITION(809:827)	CHAR
,cd_secteur_cig        		POSITION(828:843)	CHAR
,cd_gr_industrie_cig   		POSITION(844:863)	CHAR
,cd_industrie_cig      		POSITION(864:880)	CHAR
,cd_sous_industrie_cig 		POSITION(881:902)	CHAR
,cd_indice_ref         		POSITION(903:916)	CHAR
,cd_sect_ref           		POSITION(917:928)	CHAR
,cd_sous_sect_ref      		POSITION(929:945)	CHAR
,cd_industrie_ref      		POSITION(946:962)	CHAR
,cd_sous_industrie_ref 		POSITION(963:984)	CHAR
,cd_dernier_niveau_ref 		POSITION(985:1006)	CHAR
,cd_secteur_cig2       		POSITION(1007:1022)	CHAR
,cd_sous_secteur_cig2  		POSITION(1023:1043)	CHAR
,cd_origine_geo        		POSITION(1044:1058)	CHAR
,quant_emise     		POSITION(1059:1077)	"TO_NUMBER(:quant_emise,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,descr_titre     		POSITION(1078:1117)	CHAR
,cd_emetteur			POSITION(1118:1129)	CHAR
,cd_pays_emetteur_iso  		POSITION(1130:1150)	CHAR
,cd_pays_titre       		POSITION(1151:1166)	CHAR
,cd_categ_gen_plac     		POSITION(1167:1184)	CHAR
,cd_type_instrument    		POSITION(1185:1203)	CHAR
,freq_coupon           		POSITION(1204:1215)	CHAR
,cd_type_emission      		POSITION(1216:1232)	CHAR
,cd_classe_emission    		POSITION(1233:1251)	CHAR
,performance_class     		POSITION(1252:1268)	CHAR
)